Cannot display data from another column due to first visible cell default.
Cause:
Combo box displays data from the first visible column in the list by default.
Solution:
In the Forms Design view, use the 'Column Widths' property box in the property sheet to control which columns are displayed.
1) If the Database window is not activated, activate the Database window.
2) Click the 'Forms' tab in the Database window.
Forms tab
3) Select the desired form from the list. (The selected form is highlighted.)
4) Click 'Design'. (The selected form appears in Design view, and the floating Toolbox appears.)
5) Select the 'View' menu and select 'Properties'. (The property sheet appears.)
6) Click on the desired combo box in the form. (Handles appear around the combo box.)
7) Click the 'Format' tab in the property sheet.
8) Click on the 'Column Widths' box. (A blinking cursor appears with the column widths highlighted.)
9) Position the cursor at the beginning of the box. (The column widths are not highlighted.)
10) Delete the desired column dimension.
NOTE: Do not delete the semi-colon.
11) Type a '0' for the desired column to be hidden.
12) Select the 'File' menu and select 'Save' to save changes to the form.
